Skip to main content

Import Fixed Width Data File

Overview


Imports fixed width data from a file using a defined number of characters per column.

Input

Read Data From File

NameRequiredDescription
File PathThe full path to the file
ColumnsThe columns that make up the file

Advanced

NameRequiredDescription
Trim WhitespaceConfigure whether fields are trimmed of whitespace. Can specify trimming the left or right of the field, both or neither
Fixed Width ModeConfigure how the final column is parsed. Some files may terminate a line early or have a large unused buffer at the last field in a line

Output

Output Table The table read from the provided file